SQL Anywhere is a relational database management system (RDBMS) product from the company Sybase iAnywhere, a subsidiary of Sybase.
Contents |
SQL Anywhere can be run on Windows, Windows CE, Mac OS X, and various UNIX platforms, including Linux, AIX, HP-UX and Solaris. Database files are independent of the operating system, allowing them to be copied between supported platforms. The product provides several standard interfaces (ODBC, JDBC, and ADO.NET) and a number of special interfaces such as PHP and Perl. The engine supports stored procedures, user functions (using Watcom SQL, T-SQL, Java, or C/C++), triggers, referential integrity, row-level locking, replication, proxy tables, and events (scheduled and system events). Strong encryption is supported for both database files and client-server communication.
SQL Anywhere is used in several contexts, including as an embedded database, particularly as an application data store. For example, it is used in Intuit QuickBooks[1], in network management products, and in backup products. Its ability to be used with minimal administration is a distinguishing feature in this role. It can be used as a database server for work groups or for small or medium-sized businesses. It can also function as a mobile database. It includes scalable data synchronization technology that provides change-based replication between separate databases, including large server-based RDBMS systems.